[fn_GetStatus2].sql 342 B

12345678910111213141516171819
  1. USE [db]
  2. GO
  3. /****** ¶ÔÏó: UserDefinedFunction [dbo].[fn_GetStatus2] ½Å±¾ÈÕÆÚ: 11/09/2015 10:26:39 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. create function [dbo].[fn_GetStatus2](@field varchar(10))
  9. returns int
  10. as
  11. begin
  12. declare @retval int
  13. if @field = 'δȡ'
  14. set @retval = 0
  15. else
  16. set @retval = 1
  17. return @retval
  18. end